Skip to main Content

IBM Db2 12.1: Performance and Tuning Optimization for Relational DBAs

This course equips experienced database administrators with the skills needed to analyze, tune, and optimize the performance of IBM Db2 12 for Linux, UNIX, and Windows.

Participants will learn how to interpret and influence the Db2 query optimization process using statistical metadata, develop efficient indexing strategies for high-performance workloads, and apply advanced tools such as EXPLAIN, db2pd, and the Db2 Data Management Console to evaluate and refine SQL access paths.

The course also introduces the Db2 AI Optimizer and automation techniques that simplify statistics collection and performance diagnostics. Emphasis is placed on real-world use cases, practical monitoring methods, and proactive tuning practices to ensure scalable and efficient database operations in enterprise environments.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Delivery Format

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

3 courses found

    • Delivery Format: Virtual Learning
    • Date 20 April, 2026 | 9:00 AM to 5:00 PM
    • Location: Virtual (W. Europe )
    • Language: English

    eur850.00

    • Delivery Format: Virtual Learning
    • Date 13 July, 2026 | 9:00 AM to 5:00 PM
    • Location: Virtual (W. Europe )
    • Language: English

    eur850.00

    • Delivery Format: Virtual Learning
    • Date 16 November, 2026 | 9:00 AM to 5:00 PM
    • Location: Virtual (W. Europe )
    • Language: English

    eur850.00

Request a date or location for this course

Dates in Other Countries